Setting up MySQL database replication [without restarting mysql]
Posted
by
FunkyChicken
on Server Fault
See other posts from Server Fault
or by FunkyChicken
Published on 2012-10-26T09:10:10Z
Indexed on
2012/10/26
11:03 UTC
Read the original article
Hit count: 381
I'm trying to setup MySQL db replication, it seems pretty straight forward.
I was using this tutorial: http://www.howtoforge.com/mysql_database_replication
Now I run a rather large MySQL database for a very large website, and in this tutorial it asks me to restart MySQL to apply the new settings in the /etc/my.cnf file.
I'm try to avoid that step at all costs, as I know that restarting MySQL can take a few minutes on my machine (due to large logs/dbs), and I don't want any downtime.
Is there a way to apply the necessary settings WITHOUT fully restarting Mysql?
© Server Fault or respective owner